﻿using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Linq;
using System.Text;
using System.Data.Entity;
using University.Workshop.Model;

namespace University.Workshop.DataAccess
{
    public class EntitiesContextInitializer : DropCreateDatabaseIfModelChanges<WFPEntities>
    {
        protected override void Seed(WFPEntities context)
        {

            #region Persons For Register
            //Admin user
            context.Person.Add(new Person() { Names = "Admin", LastNames = "Admin", PersonId = "0", Phone = "" });

            //manzano B-1
            context.Person.Add(new Person() { Names = "Ivan", LastNames = "Montes Fabrica", PersonId = "1", Phone = "" });
            context.Person.Add(new Person() { Names = "Leandro", LastNames = "Cerrudo Fernandez", PersonId = "2", Phone = "" });
            context.Person.Add(new Person() { Names = "Jhonny", LastNames = "Condori", PersonId = "3", Phone = "" });
            context.Person.Add(new Person() { Names = "Jorge", LastNames = "Condori", PersonId = "4", Phone = "" });
            context.Person.Add(new Person() { Names = "Paulina", LastNames = "Garcia Hurtado", PersonId = "5", Phone = "" });
            context.Person.Add(new Person() { Names = "Jhonny", LastNames = "Veizaga", PersonId = "6", Phone = "" });
            context.Person.Add(new Person() { Names = "Beatriz", LastNames = "Huarita", PersonId = "7", Phone = "" });
            context.Person.Add(new Person() { Names = "Emilio", LastNames = "Barrios Rojas", PersonId = "8", Phone = "" });
            context.Person.Add(new Person() { Names = "Alfredo", LastNames = "Mamani Tintaya", PersonId = "13", Phone = "" });
            context.Person.Add(new Person() { Names = "Maximiliano", LastNames = "Roman Encinas", PersonId = "14", Phone = "" });
            context.Person.Add(new Person() { Names = "Herminia", LastNames = "Roman Flores", PersonId = "15", Phone = "" });
            context.Person.Add(new Person() { Names = "Delia", LastNames = "Alarcon Vila", PersonId = "16", Phone = "" });
            context.Person.Add(new Person() { Names = "Luz Edith", LastNames = "Lozada Vasques", PersonId = "17", Phone = "" });
            context.Person.Add(new Person() { Names = "Karina", LastNames = "Getrudes Felipe", PersonId = "18", Phone = "" });
            context.Person.Add(new Person() { Names = "Teofilo", LastNames = "Lopez Callacopa", PersonId = "19", Phone = "" });
            context.Person.Add(new Person() { Names = "Sacarias", LastNames = "Villarroel", PersonId = "20", Phone = "" });
            context.Person.Add(new Person() { Names = "Luis", LastNames = "Marin Siles", PersonId = "21", Phone = "" });
            context.Person.Add(new Person() { Names = "Balerio", LastNames = "Rojas Marin", PersonId = "22", Phone = "" });
            context.Person.Add(new Person() { Names = "Ninfa", LastNames = "Rojas", PersonId = "23", Phone = "" });
            context.Person.Add(new Person() { Names = "Juanita", LastNames = "Duran", PersonId = "24", Phone = "" });
            context.Person.Add(new Person() { Names = "Sabina", LastNames = "Ordoñes Flores", PersonId = "25", Phone = "" });
            context.Person.Add(new Person() { Names = "Ronald", LastNames = "Mamani", PersonId = "27", Phone = "" });
            context.Person.Add(new Person() { Names = "Serafina", LastNames = "Encinas", PersonId = "28", Phone = "" });
            context.Person.Add(new Person() { Names = "Esperanza", LastNames = "Baltazar", PersonId = "29", Phone = "" });
            context.Person.Add(new Person() { Names = "Ruben", LastNames = "Baltazar", PersonId = "30", Phone = "" });
            context.Person.Add(new Person() { Names = "Melquiades", LastNames = "Marin", PersonId = "31", Phone = "" });
            context.Person.Add(new Person() { Names = "Nora", LastNames = "Rodrigues Nogales", PersonId = "32", Phone = "" });
            context.Person.Add(new Person() { Names = "Francisco", LastNames = "Rodriguez", PersonId = "34", Phone = "" });
            context.Person.Add(new Person() { Names = "Brigida", LastNames = "Ribera Catorceno", PersonId = "35", Phone = "" });
            context.Person.Add(new Person() { Names = "Edith", LastNames = "Lozada Vazques", PersonId = "36", Phone = "" });

            //manzano B-2
            context.Person.Add(new Person() { Names = "Vilma", LastNames = "Galindo Lopez", PersonId = "38", Phone = "" });
            context.Person.Add(new Person() { Names = "Julio", LastNames = "Reyes Cotrina", PersonId = "39", Phone = "" });
            context.Person.Add(new Person() { Names = "Emiliana", LastNames = "Cortez de Apaza", PersonId = "40", Phone = "" });
            context.Person.Add(new Person() { Names = "Miguel", LastNames = "Flores Burgos", PersonId = "44", Phone = "" });
            context.Person.Add(new Person() { Names = "Santiago", LastNames = "Gonzales Guzman", PersonId = "46", Phone = "" });
            context.Person.Add(new Person() { Names = "Adela", LastNames = "Mamani Checa", PersonId = "47", Phone = "" });
            context.Person.Add(new Person() { Names = "Richard", LastNames = "Baptista", PersonId = "49", Phone = "" });
            context.Person.Add(new Person() { Names = "Maximiliano", LastNames = "Roman Encinas", PersonId = "51", Phone = "" });
            context.Person.Add(new Person() { Names = "Miguelina", LastNames = "Torrico aguilar", PersonId = "52", Phone = "" });
            context.Person.Add(new Person() { Names = "Angelina", LastNames = "Torrico Quiñones", PersonId = "53", Phone = "" });
            context.Person.Add(new Person() { Names = "Gloria", LastNames = "Olivera Terceros", PersonId = "54", Phone = "" });
            context.Person.Add(new Person() { Names = "Desiderio", LastNames = "Flores Padilla", PersonId = "55", Phone = "" });
            context.Person.Add(new Person() { Names = "Veronica", LastNames = "Daza Organdoña", PersonId = "56", Phone = "" });
            context.Person.Add(new Person() { Names = "Nemecia", LastNames = "Herrera", PersonId = "57", Phone = "" });
            context.Person.Add(new Person() { Names = "Felipe", LastNames = "Cenzano", PersonId = "59", Phone = "" });
            context.Person.Add(new Person() { Names = "Lucio", LastNames = "Ovando", PersonId = "60", Phone = "" });
            context.Person.Add(new Person() { Names = "Celestina", LastNames = "Lopez Arroyo", PersonId = "61", Phone = "" });
            context.Person.Add(new Person() { Names = "Maximo", LastNames = "Rodrigues", PersonId = "63", Phone = "" });
            context.Person.Add(new Person() { Names = "Sandra Marlene", LastNames = "Peres", PersonId = "64", Phone = "" });
            context.Person.Add(new Person() { Names = "Cristoval", LastNames = "Choque Cala", PersonId = "66", Phone = "" });
            context.Person.Add(new Person() { Names = "Marcelo Tito", LastNames = "Copatite", PersonId = "67", Phone = "" });
            context.Person.Add(new Person() { Names = "Felicidad", LastNames = "Veizaga Aviles", PersonId = "69", Phone = "" });
            context.Person.Add(new Person() { Names = "Agustina", LastNames = "Guevera", PersonId = "71", Phone = "" });
            context.Person.Add(new Person() { Names = "Bilma Laura", LastNames = "Rengel", PersonId = "72", Phone = "" });
            context.Person.Add(new Person() { Names = "Juan Pablo", LastNames = "Choque", PersonId = "73", Phone = "" });

            //manzano B-3
            context.Person.Add(new Person() { Names = "Paulina", LastNames = "Molina Jaldin", PersonId = "74", Phone = "" });
            context.Person.Add(new Person() { Names = "Jaldin", LastNames = "Rosas Carballo", PersonId = "75", Phone = "" });
            context.Person.Add(new Person() { Names = "Norma", LastNames = "Rodriguez Olivera", PersonId = "76", Phone = "" });
            context.Person.Add(new Person() { Names = "Ramiro", LastNames = "Portuguez", PersonId = "78", Phone = "" });
            context.Person.Add(new Person() { Names = "Teresa", LastNames = "Veizaga Luther", PersonId = "79", Phone = "" });
            context.Person.Add(new Person() { Names = "Jose Gioni", LastNames = "Munachi Condori", PersonId = "80", Phone = "" });
            context.Person.Add(new Person() { Names = "Litzie", LastNames = "Veizaga", PersonId = "81", Phone = "" });
            context.Person.Add(new Person() { Names = "Eugenio", LastNames = "Terrazas Cruz", PersonId = "82", Phone = "" });
            context.Person.Add(new Person() { Names = "Ana Maria", LastNames = "Ramos", PersonId = "83", Phone = "" });
            context.Person.Add(new Person() { Names = "Juan", LastNames = "Quispe Mamani", PersonId = "85", Phone = "" });
            context.Person.Add(new Person() { Names = "Felix", LastNames = "Montaño A.", PersonId = "86", Phone = "" });
            context.Person.Add(new Person() { Names = "Eduardo", LastNames = "Quiroga Rojas", PersonId = "88", Phone = "" });
            context.Person.Add(new Person() { Names = "Isidro", LastNames = "Ponce Colque", PersonId = "89", Phone = "" });
            context.Person.Add(new Person() { Names = "Esequiel", LastNames = "Rojas", PersonId = "90", Phone = "" });
            context.Person.Add(new Person() { Names = "Andrea", LastNames = "Huallata Choqueticlla", PersonId = "91", Phone = "" });
            context.Person.Add(new Person() { Names = "Leandro", LastNames = "Choque Naira", PersonId = "92", Phone = "" });
            context.Person.Add(new Person() { Names = "Cecilio", LastNames = "Felipe F.", PersonId = "93", Phone = "" });
            context.Person.Add(new Person() { Names = "Abigail Esther", LastNames = "Lizite Zepita", PersonId = "94", Phone = "" });
            context.Person.Add(new Person() { Names = "Felix", LastNames = "Montaño Arias ", PersonId = "95", Phone = "" });
            context.Person.Add(new Person() { Names = "Martina", LastNames = "Fiesta Padilla", PersonId = "96", Phone = "" });
            context.Person.Add(new Person() { Names = "Frankhin", LastNames = "Muños Gonzales", PersonId = "97", Phone = "" });
            context.Person.Add(new Person() { Names = "Medarda", LastNames = "Guzman Soto", PersonId = "98", Phone = "" });
            context.Person.Add(new Person() { Names = "Bacilia", LastNames = "Mercado Campos", PersonId = "99", Phone = "" });
            context.Person.Add(new Person() { Names = "Cirilo", LastNames = "Fernandez", PersonId = "100", Phone = "" });
            context.Person.Add(new Person() { Names = "Olga", LastNames = "Aliaga Condori", PersonId = "101", Phone = "" });

            //manzano B-4
            context.Person.Add(new Person() { Names = "Cirilo", LastNames = "Rodriguez Pereira", PersonId = "102", Phone = "" });
            context.Person.Add(new Person() { Names = "Placido", LastNames = "Albares Velarde", PersonId = "103", Phone = "" });
            context.Person.Add(new Person() { Names = "Victor", LastNames = "Huallpa Villca", PersonId = "105", Phone = "" });
            context.Person.Add(new Person() { Names = "Irenia", LastNames = "Olivera Vargas", PersonId = "106", Phone = "" });
            context.Person.Add(new Person() { Names = "Juan Carlos", LastNames = "Medrano", PersonId = "108", Phone = "" });
            context.Person.Add(new Person() { Names = "Dora", LastNames = "Lara Alvarez", PersonId = "109", Phone = "" });
            context.Person.Add(new Person() { Names = "Sabino", LastNames = "Murillo ", PersonId = "110", Phone = "" });
            context.Person.Add(new Person() { Names = "Cristina", LastNames = "Jachacata", PersonId = "111", Phone = "" });
            context.Person.Add(new Person() { Names = "Reymunda", LastNames = "Moya Ricaldes", PersonId = "113", Phone = "" });
            context.Person.Add(new Person() { Names = "Julia", LastNames = "Zurita Parra", PersonId = "114", Phone = "" });
            context.Person.Add(new Person() { Names = "Felicia", LastNames = "Choque Canaviri", PersonId = "116", Phone = "" });
            context.Person.Add(new Person() { Names = "Isaura", LastNames = "Cadima Veizaga", PersonId = "117", Phone = "" });
            context.Person.Add(new Person() { Names = "Franz Wilfredo", LastNames = "Veizaga Cadima ", PersonId = "118", Phone = "" });
            context.Person.Add(new Person() { Names = "Cristina", LastNames = "Rodriguez", PersonId = "119", Phone = "" });
            context.Person.Add(new Person() { Names = "Rogelio", LastNames = "Mamani", PersonId = "120", Phone = "" });
            context.Person.Add(new Person() { Names = "Jeffer A.", LastNames = "Ajuacho Choque", PersonId = "122", Phone = "" });
            context.Person.Add(new Person() { Names = "Roxana", LastNames = "Merino", PersonId = "123", Phone = "" });
            context.Person.Add(new Person() { Names = "Juana", LastNames = "Rodriguez", PersonId = "124", Phone = "" });
            context.Person.Add(new Person() { Names = "Trifonia", LastNames = "Velarde Vasquez", PersonId = "125", Phone = "" });

            //manzano B-5
            context.Person.Add(new Person() { Names = "Donato", LastNames = "Vargas", PersonId = "126", Phone = "" });
            context.Person.Add(new Person() { Names = "Milta", LastNames = "Fuentes Guzman ", PersonId = "127", Phone = "" });
            context.Person.Add(new Person() { Names = "Estanislao", LastNames = "Humacacho Chocllu", PersonId = "128", Phone = "" });
            context.Person.Add(new Person() { Names = "Clemente", LastNames = "Calle Mendez", PersonId = "130", Phone = "" });
            context.Person.Add(new Person() { Names = "Mario", LastNames = "Merimo Quiroga", PersonId = "131", Phone = "" });
            context.Person.Add(new Person() { Names = "Margara", LastNames = "Morales Colque", PersonId = "132", Phone = "" });
            context.Person.Add(new Person() { Names = "Calisto", LastNames = "Rojas Gutierrez", PersonId = "133", Phone = "" });
            context.Person.Add(new Person() { Names = "Eulogio", LastNames = "Alanoca Cuico", PersonId = "134", Phone = "" });
            context.Person.Add(new Person() { Names = "Fernando", LastNames = "Alaca Pinto", PersonId = "135", Phone = "" });
            context.Person.Add(new Person() { Names = "Juan Oscar", LastNames = " Godoy C.", PersonId = "137", Phone = "" });
            context.Person.Add(new Person() { Names = "Mario", LastNames = "Vasquez", PersonId = "140", Phone = "" });
            context.Person.Add(new Person() { Names = "Virgilio", LastNames = "Cuela Cornejo", PersonId = "141", Phone = "" });
            context.Person.Add(new Person() { Names = "Dilma", LastNames = "Parada Mundocorre", PersonId = "142", Phone = "" });
            context.Person.Add(new Person() { Names = "Pablo", LastNames = "Herrera Marin ", PersonId = "143", Phone = "" });
            context.Person.Add(new Person() { Names = "Lucia", LastNames = "Paucara de Sunabia", PersonId = "144", Phone = "" });
            context.Person.Add(new Person() { Names = "Zulma", LastNames = "Antezana Olibera", PersonId = "145", Phone = "" });

            //manzano B-6
            context.Person.Add(new Person() { Names = "Juana", LastNames = "Espejo", PersonId = "100151", Phone = "" });
            context.Person.Add(new Person() { Names = "Alcides", LastNames = "Bautista Claros", PersonId = "100152", Phone = "" });
            context.Person.Add(new Person() { Names = "Mirta", LastNames = "Salazar", PersonId = "100153", Phone = "" });
            context.Person.Add(new Person() { Names = "Felix", LastNames = "Rosas Soria", PersonId = "100154", Phone = "" });
            context.Person.Add(new Person() { Names = "Mauro Rodrigues", LastNames = "Rojas", PersonId = "100155", Phone = "" });
            context.Person.Add(new Person() { Names = "Sixto", LastNames = "Rodrigues Rojas", PersonId = "100156", Phone = "" });
            context.Person.Add(new Person() { Names = "Dora", LastNames = "Rosas Castellon", PersonId = "100157", Phone = "" });
            context.Person.Add(new Person() { Names = "Agustina", LastNames = "Cossio Ayaviri", PersonId = "100158", Phone = "" });
            context.Person.Add(new Person() { Names = "Macedonio", LastNames = "Herbas Flores", PersonId = "100159", Phone = "" });
            context.Person.Add(new Person() { Names = "Flores Colque", LastNames = " Flores Colque", PersonId = "100160", Phone = "" });
            context.Person.Add(new Person() { Names = "Benigno", LastNames = "Mamani Quiroz", PersonId = "100161", Phone = "" });
            context.Person.Add(new Person() { Names = "Apolinaria", LastNames = "Yucra Choque", PersonId = "100162", Phone = "" });
            context.Person.Add(new Person() { Names = "Enrique", LastNames = "Orellana Balderrama", PersonId = "100163", Phone = "" });
            context.Person.Add(new Person() { Names = "Ancelmo", LastNames = "Ricaldes Cáseres", PersonId = "100164", Phone = "" });
            context.Person.Add(new Person() { Names = "Berhto", LastNames = "Escovar", PersonId = "100165", Phone = "" });
            context.Person.Add(new Person() { Names = "Susana", LastNames = "Espejo Vega", PersonId = "100166", Phone = "" });
            context.Person.Add(new Person() { Names = "Claudia", LastNames = "Espejo Vega", PersonId = "100167", Phone = "" });
            context.Person.Add(new Person() { Names = "Hilarion", LastNames = "Mamani Taquichiri", PersonId = "100168", Phone = "" });
            context.Person.Add(new Person() { Names = "Hugo", LastNames = "Mamani Taquichiri", PersonId = "100169", Phone = "" });
            context.Person.Add(new Person() { Names = "Ronal", LastNames = "Marin", PersonId = "100170", Phone = "" });
            context.Person.Add(new Person() { Names = "Aurelio", LastNames = "Daza", PersonId = "100171", Phone = "" });
            context.Person.Add(new Person() { Names = "Iglesia", LastNames = "-", PersonId = "100172", Phone = "" });
            context.Person.Add(new Person() { Names = "Gonzalo", LastNames = "Jimenes R", PersonId = "100173", Phone = "" });
            context.Person.Add(new Person() { Names = "Luciano", LastNames = "Olivera", PersonId = "100174", Phone = "" });
            context.Person.Add(new Person() { Names = "Bertha", LastNames = "Espejo Verduguuez", PersonId = "100175", Phone = "" });

            //manzano B-7
            context.Person.Add(new Person() { Names = "Elva", LastNames = "Siles", PersonId = "100176", Phone = "" });
            context.Person.Add(new Person() { Names = "Adriana", LastNames = "Solares Martinez", PersonId = "100177", Phone = "" });
            context.Person.Add(new Person() { Names = "Aurora", LastNames = "Garcia Parra", PersonId = "100178", Phone = "" });
            context.Person.Add(new Person() { Names = "Gabriela", LastNames = "Parra Arnez", PersonId = "100179", Phone = "" });
            context.Person.Add(new Person() { Names = "Ana Maria  Gloria", LastNames = "Camacho", PersonId = "100180", Phone = "" });
            context.Person.Add(new Person() { Names = "HIlaria", LastNames = "Higuera De Loza", PersonId = "100181", Phone = "" });
            context.Person.Add(new Person() { Names = "Josefina", LastNames = "Flores", PersonId = "100182", Phone = "" });
            context.Person.Add(new Person() { Names = "Cristina", LastNames = "Vargas", PersonId = "100183", Phone = "" });
            context.Person.Add(new Person() { Names = "julian", LastNames = "Vidal Melendres", PersonId = "100184", Phone = "" });
            context.Person.Add(new Person() { Names = "Anacleta", LastNames = "Gonzales Veizaga", PersonId = "100185", Phone = "" });
            context.Person.Add(new Person() { Names = "Edwar", LastNames = "Fernandez Munachi", PersonId = "100186", Phone = "" });
            context.Person.Add(new Person() { Names = "Praxedes ", LastNames = "Rivera Acho", PersonId = "100187", Phone = "" });
            context.Person.Add(new Person() { Names = "German", LastNames = "Zoto Gonzales", PersonId = "100188", Phone = "" });
            context.Person.Add(new Person() { Names = "Rose Mari", LastNames = "Gusman Gonzales", PersonId = "100189", Phone = "" });
            context.Person.Add(new Person() { Names = "Ariel", LastNames = "Garcia Torres", PersonId = "100190", Phone = "" });
            context.Person.Add(new Person() { Names = "Jesus", LastNames = "Garcia Torres", PersonId = "100191", Phone = "" });
            context.Person.Add(new Person() { Names = "Nemecio", LastNames = "Ñucra Condori", PersonId = "100192", Phone = "" });
            context.Person.Add(new Person() { Names = "Isabel", LastNames = "Terceros De Olivera", PersonId = "100193", Phone = "" });
            context.Person.Add(new Person() { Names = "Benita", LastNames = " Salinas Manchany", PersonId = "100194", Phone = "" });
            context.Person.Add(new Person() { Names = "Esteban", LastNames = "Kalani Mamani", PersonId = "100195", Phone = "" });
            context.Person.Add(new Person() { Names = "Carlos", LastNames = "Acha Dias", PersonId = "100196", Phone = "" });
            context.Person.Add(new Person() { Names = "Hilarion", LastNames = "Hidalgo Camacho", PersonId = "100197", Phone = "" });
            context.Person.Add(new Person() { Names = "Alfredo", LastNames = "Camacho Peres", PersonId = "100198", Phone = "" });
            context.Person.Add(new Person() { Names = "Julia", LastNames = "Peres Ardaya", PersonId = "100199", Phone = "" });
            context.Person.Add(new Person() { Names = "Aurelio", LastNames = "Camacho Peñarrieta", PersonId = "100200", Phone = "" });
            context.Person.Add(new Person() { Names = "Lidia Monica", LastNames = "Duran C.", PersonId = "100201", Phone = "" });
            context.Person.Add(new Person() { Names = "Damiana", LastNames = "Duran Camacho De Linares", PersonId = "100202", Phone = "" });
            context.Person.Add(new Person() { Names = "Apolonia", LastNames = "Quispe Moya", PersonId = "100203", Phone = "" });
            context.Person.Add(new Person() { Names = "Isidro", LastNames = " Campero Flores", PersonId = "100204", Phone = "" });
            context.Person.Add(new Person() { Names = "Emeteria", LastNames = "Mendoza Huayra", PersonId = "100205", Phone = "" });
            context.Person.Add(new Person() { Names = "Guillermo", LastNames = "Manani Chura", PersonId = "100206", Phone = "" });
            context.Person.Add(new Person() { Names = "Juan", LastNames = "Mamani Suyo", PersonId = "100207", Phone = "" });
            context.Person.Add(new Person() { Names = "Silvestre", LastNames = "Rojas Balderrama", PersonId = "100208", Phone = "" });
            context.Person.Add(new Person() { Names = "Peregrina", LastNames = "Vasques López", PersonId = "100209", Phone = "" });
            context.Person.Add(new Person() { Names = "Renberto", LastNames = "Rodrigues Vazques", PersonId = "100210", Phone = "" });
            context.Person.Add(new Person() { Names = "Eulogio", LastNames = "Mérida Duran", PersonId = "100211", Phone = "" });
            context.Person.Add(new Person() { Names = "Adriana", LastNames = "Solares", PersonId = "100212", Phone = "" });
            context.Person.Add(new Person() { Names = "Osacar", LastNames = "Guzman Mojica", PersonId = "100213", Phone = "" });
            context.Person.Add(new Person() { Names = "Dora Luz", LastNames = "Guzman", PersonId = "100214", Phone = "" });
            context.Person.Add(new Person() { Names = "Mauricio", LastNames = "Guzman", PersonId = "100215", Phone = "" });

            //manzano B-8
            context.Person.Add(new Person() { Names = "Teofilo", LastNames = "-", PersonId = "100216", Phone = "" });
            context.Person.Add(new Person() { Names = "Carlos", LastNames = "Campos Cruz", PersonId = "100217", Phone = "" });
            context.Person.Add(new Person() { Names = "Maximiliano", LastNames = "Aguilar Quispe", PersonId = "100218", Phone = "" });
            context.Person.Add(new Person() { Names = "Wilfredo", LastNames = "Argollo Garcia", PersonId = "100219", Phone = "" });
            context.Person.Add(new Person() { Names = "Juanita", LastNames = "Mirna Huanca", PersonId = "100220", Phone = "" });
            context.Person.Add(new Person() { Names = "Teodocia", LastNames = "Nicolas", PersonId = "100221", Phone = "" });
            context.Person.Add(new Person() { Names = "Nancy", LastNames = " Antoriano Antezana", PersonId = "100222", Phone = "" });
            context.Person.Add(new Person() { Names = "Cinforoza ", LastNames = "Choque Gonzales", PersonId = "100223", Phone = "" });
            context.Person.Add(new Person() { Names = "Elma", LastNames = "Calucho Montaño", PersonId = "100224", Phone = "" });
            context.Person.Add(new Person() { Names = "Willy", LastNames = "Virgilio Aduviri", PersonId = "100225", Phone = "" });
            context.Person.Add(new Person() { Names = "Juana", LastNames = "Arnez Calucho", PersonId = "100226", Phone = "" });
            context.Person.Add(new Person() { Names = "Cornelio", LastNames = "Mamani Aguilar", PersonId = "100227", Phone = "" });
            context.Person.Add(new Person() { Names = "Adalid", LastNames = "Encinas Rojas", PersonId = "100228", Phone = "" });
            context.Person.Add(new Person() { Names = "Genaro", LastNames = "Gutierrez Paca", PersonId = "100229", Phone = "" });
            context.Person.Add(new Person() { Names = "Fermina Reina", LastNames = "Quispe Q.", PersonId = "100230", Phone = "" });
            context.Person.Add(new Person() { Names = "Eusebia", LastNames = "Nabarro Condori ", PersonId = "100231", Phone = "" });
            context.Person.Add(new Person() { Names = "German", LastNames = "Castro Camacho", PersonId = "100233", Phone = "" });
            context.Person.Add(new Person() { Names = "Roberta", LastNames = "Fernandez De Pajari ", PersonId = "100236", Phone = "" });
            context.Person.Add(new Person() { Names = "Nestor", LastNames = "Carrasco Candia", PersonId = "100237", Phone = "" });
            context.Person.Add(new Person() { Names = "Tania", LastNames = "Santiestevan", PersonId = "100238", Phone = "" });
            context.Person.Add(new Person() { Names = "Wilber", LastNames = "Nabarro", PersonId = "100239", Phone = "" });
            context.Person.Add(new Person() { Names = "Petrona", LastNames = "Condori Luiz", PersonId = "100240", Phone = "" });
            context.Person.Add(new Person() { Names = "Alberto", LastNames = "Peres Condori", PersonId = "100241", Phone = "" });
            context.Person.Add(new Person() { Names = "Fredy", LastNames = "Campi Romero", PersonId = "100242", Phone = "" });
            context.Person.Add(new Person() { Names = "Tania Sonia", LastNames = "Sagardia", PersonId = "100243", Phone = "" });
            context.Person.Add(new Person() { Names = "Pascual", LastNames = "Aguirre Rojas", PersonId = "100244", Phone = "" });
            context.Person.Add(new Person() { Names = "Cristina ", LastNames = "Blanco Mamani", PersonId = "100245", Phone = "" });
            context.Person.Add(new Person() { Names = "Valeriano", LastNames = "Rojas Castro", PersonId = "100246", Phone = "" });
            context.Person.Add(new Person() { Names = "Rosemary", LastNames = "Encinas Quiñones", PersonId = "100247", Phone = "" });
            context.Person.Add(new Person() { Names = "Jesus", LastNames = "Ticona Kena ", PersonId = "100248", Phone = "" });
            context.Person.Add(new Person() { Names = "Domingo", LastNames = "Paina", PersonId = "100249", Phone = "" });
            context.Person.Add(new Person() { Names = "Hijilio", LastNames = "Tapia Gonzales ", PersonId = "100250", Phone = "" });
            context.Person.Add(new Person() { Names = "Filomon", LastNames = "Jachacollo", PersonId = "100251", Phone = "" });
            context.Person.Add(new Person() { Names = "Jachacollo", LastNames = "Rodriguez V", PersonId = "100252", Phone = "" });
            context.Person.Add(new Person() { Names = "Gregorio", LastNames = "Mayta Barreto", PersonId = "100253", Phone = "" });
            context.Person.Add(new Person() { Names = "Jhony", LastNames = "Pozo Ledezma", PersonId = "100254", Phone = "" });

            //manzano B-9
            context.Person.Add(new Person() { Names = "Martin", LastNames = "Condori Flores", PersonId = "100255", Phone = "" });
            context.Person.Add(new Person() { Names = "Epifanio", LastNames = "Chura Gonzales", PersonId = "100257", Phone = "" });
            context.Person.Add(new Person() { Names = "Octavia", LastNames = "Canaviri Marca", PersonId = "100258", Phone = "" });
            context.Person.Add(new Person() { Names = "Simona", LastNames = "Mamani Condori", PersonId = "100259", Phone = "" });
            context.Person.Add(new Person() { Names = "Sofia", LastNames = " Jaldin", PersonId = "100260", Phone = "" });
            context.Person.Add(new Person() { Names = "Esequiel", LastNames = "Caceres", PersonId = "100261", Phone = "" });
            context.Person.Add(new Person() { Names = "Antonio", LastNames = "Torrico", PersonId = "100262", Phone = "" });
            context.Person.Add(new Person() { Names = "Sofia", LastNames = "Mancilla Calle", PersonId = "100263", Phone = "" });
            context.Person.Add(new Person() { Names = "Eustaquia", LastNames = "Peña Arnez", PersonId = "100264", Phone = "" });
            context.Person.Add(new Person() { Names = "Aquilina", LastNames = "Apaza Cortez", PersonId = "100265", Phone = "" });
            context.Person.Add(new Person() { Names = "Marta", LastNames = "Rodriguez", PersonId = "100266", Phone = "" });
            context.Person.Add(new Person() { Names = "Jose", LastNames = "Vallejos Camacho", PersonId = "100267", Phone = "" });
            context.Person.Add(new Person() { Names = "Antonio", LastNames = "Rodriguez Vargas", PersonId = "100269", Phone = "" });
            context.Person.Add(new Person() { Names = "Casto", LastNames = "Terceros", PersonId = "100270", Phone = "" });
            context.Person.Add(new Person() { Names = "Gregorio", LastNames = "Revollo Terceros", PersonId = "100271", Phone = "" });
            context.Person.Add(new Person() { Names = "Simon ", LastNames = "Revollo Terceros", PersonId = "100272", Phone = "" });
            context.Person.Add(new Person() { Names = "Leonidas", LastNames = "Hinojosa Morales", PersonId = "100273", Phone = "" });
            context.Person.Add(new Person() { Names = "Rina", LastNames = "Izabel Jimenes", PersonId = "100274", Phone = "" });
            context.Person.Add(new Person() { Names = "Cristoval", LastNames = "Rodrigues Jaldin", PersonId = "100275", Phone = "" });
            context.Person.Add(new Person() { Names = "Humberto", LastNames = "Lara Alvarez", PersonId = "100276", Phone = "" });
            context.Person.Add(new Person() { Names = "Epifania", LastNames = "Lara", PersonId = "100277", Phone = "" });
            context.Person.Add(new Person() { Names = "Jaime", LastNames = "Zambrana", PersonId = "100278", Phone = "" });
            context.Person.Add(new Person() { Names = "Herminia", LastNames = "Villarroel Jaldin", PersonId = "100279", Phone = "" });
            context.Person.Add(new Person() { Names = "Maria Consepcion", LastNames = "Rodriguez", PersonId = "100280", Phone = "" });
            context.Person.Add(new Person() { Names = "Elsa", LastNames = "Espejo", PersonId = "100281", Phone = "" });

            //manzano B-10
            context.Person.Add(new Person() { Names = "Froilan", LastNames = "Flores Ledezma", PersonId = "301", Phone = "" });
            context.Person.Add(new Person() { Names = "David", LastNames = "Arnez Calucho", PersonId = "302", Phone = "" });
            context.Person.Add(new Person() { Names = "Juan de Dios", LastNames = "Pozo", PersonId = "303", Phone = "" });
            context.Person.Add(new Person() { Names = "alejandrina", LastNames = "Pozo Rojas", PersonId = "304", Phone = "" });
            context.Person.Add(new Person() { Names = "Simon Benito", LastNames = "Chambi", PersonId = "305", Phone = "" });
            context.Person.Add(new Person() { Names = "Roxana", LastNames = "Fernandez", PersonId = "306", Phone = "" });
            context.Person.Add(new Person() { Names = "Norma", LastNames = "Reojas Vellejos", PersonId = "307", Phone = "" });
            context.Person.Add(new Person() { Names = "Sandra", LastNames = "Pedro Vega", PersonId = "308", Phone = "" });
            context.Person.Add(new Person() { Names = "Ricardo", LastNames = "Zaigua Cruz", PersonId = "309", Phone = "" });
            context.Person.Add(new Person() { Names = "Eliodoro", LastNames = "Heridia Flores", PersonId = "310", Phone = "" });
            context.Person.Add(new Person() { Names = "Benigno", LastNames = "Mayta Barreto", PersonId = "311", Phone = "" });
            context.Person.Add(new Person() { Names = "Eusevia", LastNames = "Calle  MARZA de flores", PersonId = "312", Phone = "" });
            context.Person.Add(new Person() { Names = "Cristina", LastNames = "Salguero", PersonId = "313", Phone = "" });
            context.Person.Add(new Person() { Names = "Beatriz", LastNames = " Ayaviri", PersonId = "314", Phone = "" });
            context.Person.Add(new Person() { Names = "Roberto", LastNames = "peres Guzman", PersonId = "315", Phone = "" });
            context.Person.Add(new Person() { Names = "Guillermina", LastNames = "", PersonId = "316", Phone = "" });
            context.Person.Add(new Person() { Names = " Filomeno", LastNames = "herrera Franco", PersonId = "318", Phone = "" });
            context.Person.Add(new Person() { Names = "Jesus", LastNames = "Zenteno", PersonId = "320", Phone = "" });
            context.Person.Add(new Person() { Names = "Maribel", LastNames = "Zenteno", PersonId = "321", Phone = "" });
            context.Person.Add(new Person() { Names = "Casto", LastNames = "Saavedra Valero", PersonId = "322", Phone = "" });
            context.Person.Add(new Person() { Names = "Flora", LastNames = "Rojas Ascarraga", PersonId = "323", Phone = "" });
            context.Person.Add(new Person() { Names = "Humberto ", LastNames = "Antezana", PersonId = "324", Phone = "" });
            context.Person.Add(new Person() { Names = "Elia", LastNames = "Hinojosa Coordova", PersonId = "325", Phone = "" });
            context.Person.Add(new Person() { Names = "Erasmo", LastNames = "Vallejos rodriguez", PersonId = "326", Phone = "" });
            context.Person.Add(new Person() { Names = "Cirilo", LastNames = "Roman Flores", PersonId = "327", Phone = "" });
            context.Person.Add(new Person() { Names = "Asunta", LastNames = "Cordova", PersonId = "328", Phone = "" });
            context.Person.Add(new Person() { Names = "Leonor", LastNames = "Arzez", PersonId = "329", Phone = "" });
            context.Person.Add(new Person() { Names = "Gabriel ", LastNames = "Calizaya Cruz", PersonId = "330", Phone = "" });
            context.Person.Add(new Person() { Names = "Efrain", LastNames = "Churata Motaño", PersonId = "331", Phone = "" });
            context.Person.Add(new Person() { Names = "German", LastNames = "Condori", PersonId = "332", Phone = "" });
            context.Person.Add(new Person() { Names = "Martha", LastNames = "Mena", PersonId = "333", Phone = "" });


            //Manzano B-11
            context.Person.Add(new Person() { Names = "Florentina", LastNames = "Acarapi", PersonId = "334", Phone = "" });
            context.Person.Add(new Person() { Names = "Adalit", LastNames = "Maldonado", PersonId = "335", Phone = "" });
            context.Person.Add(new Person() { Names = "Agustina", LastNames = "Rodriguez", PersonId = "336", Phone = "" });
            context.Person.Add(new Person() { Names = "Faustino", LastNames = "Canqui", PersonId = "337", Phone = "" });
            context.Person.Add(new Person() { Names = "Eduardo", LastNames = "Willca", PersonId = "338", Phone = "" });
            context.Person.Add(new Person() { Names = "Santos", LastNames = "Bireyra Rioja", PersonId = "339", Phone = "" });
            context.Person.Add(new Person() { Names = "pablo", LastNames = "Nina Copa", PersonId = "340", Phone = "" });
            context.Person.Add(new Person() { Names = "Sofia", LastNames = "Quispe de choque", PersonId = "341", Phone = "" });
            context.Person.Add(new Person() { Names = "Valeria", LastNames = "Quisfer", PersonId = "342", Phone = "" });
            context.Person.Add(new Person() { Names = "Leocadio", LastNames = "Lazarte Peredo", PersonId = "343", Phone = "" });
            context.Person.Add(new Person() { Names = "Miguel", LastNames = "Munachi Condori", PersonId = "344", Phone = "" });
            context.Person.Add(new Person() { Names = "Pedro", LastNames = "Teran", PersonId = "345", Phone = "" });
            context.Person.Add(new Person() { Names = "Eusebia", LastNames = "Munachi Santa Ana", PersonId = "346", Phone = "" });
            context.Person.Add(new Person() { Names = "Juvenal", LastNames = "Quispe", PersonId = "347", Phone = "" });
            context.Person.Add(new Person() { Names = "Celestino", LastNames = "Romero Polo", PersonId = "348", Phone = "" });
            context.Person.Add(new Person() { Names = "Pedro", LastNames = "Aguilar", PersonId = "349", Phone = "" });
            context.Person.Add(new Person() { Names = "Zenon", LastNames = "Perez Lopez", PersonId = "350", Phone = "" });
            context.Person.Add(new Person() { Names = "Barbara", LastNames = "Ayavire", PersonId = "351", Phone = "" });
            context.Person.Add(new Person() { Names = "Rose Mary Rose", LastNames = "Morales", PersonId = "352", Phone = "" });
            context.Person.Add(new Person() { Names = "Cinda", LastNames = "Almanza Villaroel", PersonId = "353", Phone = "" });
            context.Person.Add(new Person() { Names = "Celestino", LastNames = "Romero Polo", PersonId = "354", Phone = "" });
            context.Person.Add(new Person() { Names = "Julio", LastNames = "Llampa", PersonId = "355", Phone = "" });
            context.Person.Add(new Person() { Names = "Simed", LastNames = "Claros Quinteros", PersonId = "357", Phone = "" });
            context.Person.Add(new Person() { Names = "Fernado", LastNames = "Aliaga", PersonId = "359", Phone = "" });
            context.Person.Add(new Person() { Names = "Wilson", LastNames = "Merino", PersonId = "360", Phone = "" });
            context.Person.Add(new Person() { Names = "Nora", LastNames = "Flores Chambi", PersonId = "361", Phone = "" });
            context.Person.Add(new Person() { Names = "Paulina", LastNames = "Llanque", PersonId = "362", Phone = "" });
            context.Person.Add(new Person() { Names = "Lupe", LastNames = "Noga Rodriguez carvajal", PersonId = "364", Phone = "" });
            context.Person.Add(new Person() { Names = "Cristian", LastNames = "Azcarraga Teran", PersonId = "366", Phone = "" });
            context.Person.Add(new Person() { Names = "Erasmo", LastNames = "Terrazas Claros", PersonId = "367", Phone = "" });

            //Manzano B-12
            context.Person.Add(new Person() { Names = "Remy", LastNames = "Gonzales Acuña", PersonId = "368", Phone = "" });
            context.Person.Add(new Person() { Names = "Guido", LastNames = "Maldonado", PersonId = "369", Phone = "" });
            context.Person.Add(new Person() { Names = "Adelio Adalid", LastNames = "Morales Cuevas", PersonId = "370", Phone = "" });
            context.Person.Add(new Person() { Names = "Sebastin", LastNames = "Flores montaño", PersonId = "371", Phone = "" });
            context.Person.Add(new Person() { Names = "Ramiro", LastNames = "Flores Padilla", PersonId = "372", Phone = "" });
            context.Person.Add(new Person() { Names = "Roxana", LastNames = "Motaño Villarroel", PersonId = "373", Phone = "" });
            context.Person.Add(new Person() { Names = "Siliva", LastNames = "Motaño Villarroel", PersonId = "374", Phone = "" });
            context.Person.Add(new Person() { Names = "Miriam", LastNames = "Montaño Villarroel", PersonId = "375", Phone = "" });
            context.Person.Add(new Person() { Names = "Cristina", LastNames = "Condori", PersonId = "376", Phone = "" });
            context.Person.Add(new Person() { Names = "Wanderlenny", LastNames = "Jenny Catari Hidalgo", PersonId = "377", Phone = "" });
            context.Person.Add(new Person() { Names = "Walter", LastNames = "Cruz", PersonId = "378", Phone = "" });
            context.Person.Add(new Person() { Names = "Iglessia", LastNames = "", PersonId = "379", Phone = "" });
            context.Person.Add(new Person() { Names = "Nelly", LastNames = "Paredes Velasco", PersonId = "380", Phone = "" });
            context.Person.Add(new Person() { Names = "Mario", LastNames = "Fernandez Romero", PersonId = "381", Phone = "" });
            context.Person.Add(new Person() { Names = "Ever", LastNames = "Condori Arias", PersonId = "382", Phone = "" });
            context.Person.Add(new Person() { Names = "Florencia", LastNames = "Laime Mamani", PersonId = "383", Phone = "" });
            context.Person.Add(new Person() { Names = "Jorge", LastNames = "Condori Arias", PersonId = "384", Phone = "" });
            context.Person.Add(new Person() { Names = "Rocio", LastNames = "Fernandez", PersonId = "385", Phone = "" });
            context.Person.Add(new Person() { Names = "Casto", LastNames = "Cari Cari", PersonId = "386", Phone = "" });
            context.Person.Add(new Person() { Names = "Celedonia", LastNames = "Paules Teran", PersonId = "387", Phone = "" });

            //Manzano B-13
            context.Person.Add(new Person() { Names = "Benigna", LastNames = "Mendoza Ayaviri", PersonId = "388", Phone = "" });
            context.Person.Add(new Person() { Names = "Cecilia", LastNames = "Flores V", PersonId = "389", Phone = "" });
            context.Person.Add(new Person() { Names = "Efrain", LastNames = "Caceres", PersonId = "390", Phone = "" });
            context.Person.Add(new Person() { Names = "Felix", LastNames = "Rojas Arispe", PersonId = "391", Phone = "" });
            context.Person.Add(new Person() { Names = "Gerardo", LastNames = "Ribera Soto", PersonId = "392", Phone = "" });
            context.Person.Add(new Person() { Names = "Luisa", LastNames = "Rojas", PersonId = "393", Phone = "" });
            context.Person.Add(new Person() { Names = "Orlando", LastNames = "Camacho", PersonId = "394", Phone = "" });
            context.Person.Add(new Person() { Names = "Flora", LastNames = "Lazar de chavez", PersonId = "395", Phone = "" });
            context.Person.Add(new Person() { Names = "Jhaneth", LastNames = "Quisque huanca", PersonId = "396", Phone = "" });
            context.Person.Add(new Person() { Names = "Fredy", LastNames = "Quispe Huanca", PersonId = "397", Phone = "" });
            context.Person.Add(new Person() { Names = "Marizabel", LastNames = "Antoriano", PersonId = "398", Phone = "" });
            context.Person.Add(new Person() { Names = "Isabel", LastNames = "Vela Gonzales", PersonId = "399", Phone = "" });
            context.Person.Add(new Person() { Names = "Remberto", LastNames = "Gutierres", PersonId = "400", Phone = "" });
            context.Person.Add(new Person() { Names = "Maximo", LastNames = "Saavedra", PersonId = "401", Phone = "" });
            context.Person.Add(new Person() { Names = "Elizabeth", LastNames = "Urquieta Rosales", PersonId = "402", Phone = "" });
            context.Person.Add(new Person() { Names = "Nataniel", LastNames = "Mamani Astulla", PersonId = "403", Phone = "" });
            context.Person.Add(new Person() { Names = "Juan ", LastNames = "Llaveta Mamani", PersonId = "404", Phone = "" });
            context.Person.Add(new Person() { Names = "Ponciano", LastNames = "Chujllo", PersonId = "405", Phone = "" });
            context.Person.Add(new Person() { Names = "Carmela", LastNames = "Quispe Rojas", PersonId = "406", Phone = "" });
            context.Person.Add(new Person() { Names = "Maxima", LastNames = "Calania de saca", PersonId = "407", Phone = "" });
            context.Person.Add(new Person() { Names = "Ricardo", LastNames = "Chara Flores", PersonId = "408", Phone = "" });
            context.Person.Add(new Person() { Names = "Saturnino", LastNames = "Veizaga", PersonId = "409", Phone = "" });
            context.Person.Add(new Person() { Names = "Samuel", LastNames = "Nina Zullca", PersonId = "410", Phone = "" });
            context.Person.Add(new Person() { Names = "Protacio", LastNames = "Catorceno Pascual", PersonId = "411", Phone = "" });
            context.Person.Add(new Person() { Names = "juan", LastNames = "Lopez Concepcion", PersonId = "412", Phone = "" });
            context.Person.Add(new Person() { Names = "Beatriz", LastNames = "Antoriano Antezana", PersonId = "413", Phone = "" });
            context.Person.Add(new Person() { Names = "Anastacio", LastNames = "Chiquipa secales", PersonId = "414", Phone = "" });
            context.Person.Add(new Person() { Names = "Angela", LastNames = "Arnez de Merino", PersonId = "415", Phone = "" });
            context.Person.Add(new Person() { Names = "Berta", LastNames = "Garcia", PersonId = "417", Phone = "" });
            context.Person.Add(new Person() { Names = "Eugenia", LastNames = "Vallejos rodriguez", PersonId = "419", Phone = "" });
            context.Person.Add(new Person() { Names = "Teofilo Valeriano", LastNames = "Tarqui", PersonId = "420", Phone = "" });
            context.Person.Add(new Person() { Names = "Maxima", LastNames = "Maida Gutierres", PersonId = "421", Phone = "" });
            context.Person.Add(new Person() { Names = "Alenjandrina", LastNames = "Rodriguez", PersonId = "422", Phone = "" });


            context.SaveChanges();
            #endregion

            #region Users For Register
            // Admin user
            context.User.Add(new User() { UserId = "0", Login = "admin", Role = 0, IsActive = true, Password = "admin" });

            context.SaveChanges();
            #endregion

            #region Squares and Allotment For Register

            context.Square.Add(new Square() { SquareId = "B1", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B2", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B3", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B4", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B5", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B6", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B7", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B8", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B9", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B10", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B11", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B12", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B13", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B14", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B15", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B16", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B17", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B18", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B19", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B20", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B21", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B22", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B23", Comment = "", Enable = true });
            context.Square.Add(new Square() { SquareId = "B24", Comment = "", Enable = true });

            //manzano B1
            context.Allotment.Add(new Allotment() { AllotmentName = "12", SquareId = "B1", Enable = true });

            //manzano B3
            context.Allotment.Add(new Allotment() { AllotmentName = "4", SquareId = "B3", Enable = true });

            //manzano B5
            context.Allotment.Add(new Allotment() { AllotmentName = "3", SquareId = "B5", Enable = true });

            //manzano B8
            context.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B8", Enable = true });
            context.Allotment.Add(new Allotment() { AllotmentName = "23", SquareId = "B8", Enable = true });
            context.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B8", Enable = true });

            //manzano B9
            context.Allotment.Add(new Allotment() { AllotmentName = "2", SquareId = "B9", Enable = true });
            context.Allotment.Add(new Allotment() { AllotmentName = "16", SquareId = "B9", Enable = true });

            //manzano B-10
            context.Allotment.Add(new Allotment() { AllotmentName = "20", SquareId = "B10", Enable = true });
            context.Allotment.Add(new Allotment() { AllotmentName = "24", SquareId = "B10", Enable = true });
            //manzano B-11
            context.Allotment.Add(new Allotment() { AllotmentName = "31", SquareId = "B11", Enable = true });
            context.Allotment.Add(new Allotment() { AllotmentName = "33", SquareId = "B11", Enable = true });
            context.Allotment.Add(new Allotment() { AllotmentName = "40", SquareId = "B11", Enable = true });
            context.Allotment.Add(new Allotment() { AllotmentName = "42", SquareId = "B11", Enable = true });
            //manzano B-13
            context.Allotment.Add(new Allotment() { AllotmentName = "35", SquareId = "B13", Enable = true });
            context.Allotment.Add(new Allotment() { AllotmentName = "40", SquareId = "B13", Enable = true });

            context.SaveChanges();

            #endregion

            #region Kardex For Register



            //manzano B-1
            //context.Kardex.Add(new Kardex()
            //{
            //    ClientId = "1",
            //    WaterMeasurer = "A11L342653",
            //    Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B5", Enable = true } },
            //    CollectsControls = new Collection<CollectControl>() { 
            //            new WaterCollectControl() { IsPaid = false, DateGenerated = DateTime.Now, CollectType = 0, PaymentAmount = 10, UserId = "0", ReadingDate = DateTime.Now, WaterReadingId=1 },
            //            new OtherCollectControl() { ControlDetail = "Reconexion", DateGenerated = DateTime.Now, CollectType = 0, PaymentAmount = 20, UserId = "0"},
            //            new FineCollectControl() { IsPaid = false, DateGenerated = DateTime.Now, CollectType = 0, PaymentAmount = 15, UserId = "0", ControlDate = DateTime.Now}},
            //    WaterReadingControls = new Collection<WaterReadingControl>() { new WaterReadingControl() {ReadingDate = DateTime.Now.AddMonths(-1), ReadingState = 0 } },
            //    Enable = true,
            //    HasAWaterMeasurer = true
            //});

            //context.Kardex.Add(new Kardex()
            //{
            //    ClientId = "2",
            //    WaterMeasurer = "A11L381671",
            //    Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B5", Enable = true } },
            //    CollectsControls = new Collection<CollectControl>() { new WaterCollectControl() { IsPaid = false, DateGenerated = DateTime.Now, CollectType = 0, PaymentAmount = 40, UserId = "0", ReadingDate = DateTime.Now, WaterReadingId=2 },
            //            new OtherCollectControl() { ControlDetail = "Conexion", DateGenerated = DateTime.Now, CollectType = 0, PaymentAmount = 50, UserId = "0"},
            //            new FineCollectControl() { IsPaid = false, DateGenerated = DateTime.Now, CollectType = 0, PaymentAmount = 25, UserId = "0", ControlDate = DateTime.Now}},
            //    WaterReadingControls = new Collection<WaterReadingControl>() { new WaterReadingControl() {ReadingDate = DateTime.Now.AddMonths(-1), ReadingState = 1 } },
            //    Enable = true,
            //    HasAWaterMeasurer = true
            //});

            //context.Kardex.Add(new Kardex()
            //{
            //    ClientId = "3",
            //    WaterMeasurer = "A11L282658",
            //    Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B5", Enable = true } },
            //    Enable = true,
            //    HasAWaterMeasurer = true,
            //    WaterReadingControls = new Collection<WaterReadingControl>() { new WaterReadingControl() {ReadingDate = DateTime.Now.AddMonths(-1), ReadingState = 2 } }
            //});
            //context.Kardex.Add(new Kardex()
            //{
            //    ClientId = "4",
            //    WaterMeasurer = "A11L282667",
            //    Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B5", Enable = true } },
            //    Enable = true,
            //    HasAWaterMeasurer = true,
            //    WaterReadingControls = new Collection<WaterReadingControl>() { new WaterReadingControl() {ReadingDate = DateTime.Now.AddMonths(-2), ReadingState = 1 } }
            //});
            //context.Kardex.Add(new Kardex()
            //{
            //    ClientId = "5",
            //    WaterMeasurer = "A11L341065",
            //    Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B5", Enable = true } },
            //    Enable = true,
            //    HasAWaterMeasurer = true,
            //    WaterReadingControls = new Collection<WaterReadingControl>() { new WaterReadingControl() {ReadingDate = DateTime.Now.AddMonths(-1), ReadingState = 1 } }
            //});
            //context.Kardex.Add(new Kardex()
            //{
            //    ClientId = "6",
            //    WaterMeasurer = "A11L282673",
            //    Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B5", Enable = true } },
            //    Enable = true,
            //    HasAWaterMeasurer = true,
            //    WaterReadingControls = new Collection<WaterReadingControl>() { new WaterReadingControl() {ReadingDate = DateTime.Now.AddMonths(-1), ReadingState = 1 } }
            //});
            //context.Kardex.Add(new Kardex()
            //{
            //    ClientId = "7",
            //    WaterMeasurer = "A11L282278",
            //    Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B5", Enable = true } },
            //    Enable = true,
            //    HasAWaterMeasurer = true,
            //    WaterReadingControls = new Collection<WaterReadingControl>() { new WaterReadingControl() {ReadingDate = DateTime.Now.AddMonths(-1), ReadingState = 1 } }
            //});
            //context.Kardex.Add(new Kardex()
            //{
            //    ClientId = "8",
            //    WaterMeasurer = "A11L282662",
            //    Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B5", Enable = true } },
            //    Enable = true,
            //    HasAWaterMeasurer = true,
            //    WaterReadingControls = new Collection<WaterReadingControl>() { new WaterReadingControl() {ReadingDate = DateTime.Now.AddMonths(-1), ReadingState = 1 } }
            //});
            //context.Kardex.Add(new Kardex()
            //{
            //    ClientId = "13",
            //    WaterMeasurer = "A11L282746",
            //    Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B5", Enable = true } },
            //    Enable = true,
            //    HasAWaterMeasurer = true,
            //    WaterReadingControls = new Collection<WaterReadingControl>() { new WaterReadingControl() {ReadingDate = DateTime.Now.AddMonths(-1), ReadingState = 1 } }
            //});
            context.Kardex.Add(new Kardex() { ClientId = "14", WaterMeasurer = "A11L283241", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "15", WaterMeasurer = "A11L283242", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "16", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "17", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "18", WaterMeasurer = "A11L340793", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "19", WaterMeasurer = "A11L339992", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "20", WaterMeasurer = "A11L340794", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "21", WaterMeasurer = "A11L339991", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "22", WaterMeasurer = "A11L340947", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "23", WaterMeasurer = "A11L281457", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "24", WaterMeasurer = "A11L339994", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "25", WaterMeasurer = "A11L282018", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "27", WaterMeasurer = "A11L282751", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "28", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "29", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "30", WaterMeasurer = "A11L340796", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "31", WaterMeasurer = "A11L339993", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "32", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "34", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "35", WaterMeasurer = "A11L282285", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "36", WaterMeasurer = "A11L282663", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });

            //manzano B-2
            context.Kardex.Add(new Kardex() { ClientId = "38", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "39", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "40", WaterMeasurer = "A11L282522", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "44", WaterMeasurer = "A11L282521", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "46", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "47", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "49", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "51", WaterMeasurer = "A11L283241", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "52", WaterMeasurer = "A11L369624", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "53", WaterMeasurer = "A11L340875", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "54", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "55", WaterMeasurer = "A11L282525", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "56", WaterMeasurer = "A11L339998", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "57", WaterMeasurer = "A11L282286", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "59", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "60", WaterMeasurer = "A11L282743", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "61", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "63", WaterMeasurer = "A11L282739", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "64", WaterMeasurer = "A11L282674", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "66", WaterMeasurer = "A11L282281", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "67", WaterMeasurer = "A11L282277", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "69", WaterMeasurer = "A11L282740", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "71", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "72", WaterMeasurer = "A11L340791", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "73", WaterMeasurer = "A11L341546", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });

            //manzano B-3
            context.Kardex.Add(new Kardex() { ClientId = "74", WaterMeasurer = "A11L341549", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "75", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "76", WaterMeasurer = "A11L341540", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "78", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "79", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "80", WaterMeasurer = "A11L342424", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "81", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "82", WaterMeasurer = "A11L342422", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "83", WaterMeasurer = "A11L282017", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "85", WaterMeasurer = "A11L281469", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "86", WaterMeasurer = "A11L281461", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "88", WaterMeasurer = "A11L341543", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "89", WaterMeasurer = "A11L339626", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "90", WaterMeasurer = "A11L283741", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "91", WaterMeasurer = "A11L282518", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "92", WaterMeasurer = "A11L282517", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "93", WaterMeasurer = "A11L282238", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "94", WaterMeasurer = "A11L283744", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "95", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "96", WaterMeasurer = "A11L283737", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "97", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "98", WaterMeasurer = "A11L282526", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "99", WaterMeasurer = "A11L283746", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100", WaterMeasurer = "A11L282520", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "101", WaterMeasurer = "A11L341750", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });

            //manzano B-4
            context.Kardex.Add(new Kardex() { ClientId = "102", WaterMeasurer = "A11L283536", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "103", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "105", WaterMeasurer = "A11L282752", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "106", WaterMeasurer = "A11L341547", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "108", WaterMeasurer = "A11L342429", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "109", WaterMeasurer = "A11L339997", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "110", WaterMeasurer = "A11L281473", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "111", WaterMeasurer = "A11L282753", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "113", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "114", WaterMeasurer = "A11L282241", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "116", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "117", WaterMeasurer = "A11L284728", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "118", WaterMeasurer = "A11L282747", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "119", WaterMeasurer = "A11L340797", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "120", WaterMeasurer = "A11L340795", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "122", WaterMeasurer = "A11L341544", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "123", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "124", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "125", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

            //manzano B-5
            context.Kardex.Add(new Kardex() { ClientId = "126", WaterMeasurer = "A11L341545", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "127", WaterMeasurer = "A11L281475", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "128", WaterMeasurer = "A11L281471", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "130", WaterMeasurer = "A11L281576", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "131", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "132", WaterMeasurer = "A11L281773", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "133", WaterMeasurer = "A11L281774", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "134", WaterMeasurer = "A11L281956", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "135", WaterMeasurer = "A11L341062", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "137", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "140", WaterMeasurer = "A11L282239", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "141", WaterMeasurer = "A11L282021", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "142", WaterMeasurer = "A11L282749", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "143", WaterMeasurer = "A11L342421", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "144", WaterMeasurer = "A11L341548", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "145", WaterMeasurer = "A11L281468", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B5", Enable = true } }, Enable = true, HasAWaterMeasurer = true });

            //manzano B-6
            context.Kardex.Add(new Kardex() { ClientId = "100151", WaterMeasurer = "A11L282283", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100152", WaterMeasurer = "A11L282664", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100153", WaterMeasurer = "A11L339996", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100154", WaterMeasurer = "A11L282665", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100155", WaterMeasurer = "A11L282659", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100156", WaterMeasurer = "A11L282279", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100157", WaterMeasurer = "A11L282666", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100158", WaterMeasurer = "A11L342656", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100159", WaterMeasurer = "A11L341360", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100160", WaterMeasurer = "A11L281669", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100161", WaterMeasurer = "A11L281568", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100162", WaterMeasurer = "A11L282282", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100163", WaterMeasurer = "A11L282741", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100164", WaterMeasurer = "A11L283240", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100165", WaterMeasurer = "A11L341943", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100166", WaterMeasurer = "A11L282742", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100167", WaterMeasurer = "A11L282738", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100168", WaterMeasurer = "A11L283739", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100169", WaterMeasurer = "A11L282242", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100170", WaterMeasurer = "A11L341758", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100171", WaterMeasurer = "A11L281569", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100172", WaterMeasurer = "A11L281668", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24.25", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100173", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100174", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100175", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B6", Enable = true } }, Enable = true, HasAWaterMeasurer = false });

            //manzano B-7
            context.Kardex.Add(new Kardex() { ClientId = "100176", WaterMeasurer = "A11L283244", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100177", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100178", WaterMeasurer = "A11L282754", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100179", WaterMeasurer = "A11L282744", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100180", WaterMeasurer = "A11L340871", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100181", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100182", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100183", WaterMeasurer = "A11L283239", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100184", WaterMeasurer = "A11L282737", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100185", WaterMeasurer = "A11L281776", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100186", WaterMeasurer = "A11L282745", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100187", WaterMeasurer = "A11L341069", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100188", WaterMeasurer = "A11L281952", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100189", WaterMeasurer = "A11L281570", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100190", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100191", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100192", WaterMeasurer = "A11L281775", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100193", WaterMeasurer = "A11L281534", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100194", WaterMeasurer = "A11L281529", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100195", WaterMeasurer = "A11L", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100196", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100197", WaterMeasurer = "A11L282676", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100198", WaterMeasurer = "A11L282671", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100199", WaterMeasurer = "A11L282675", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100200", WaterMeasurer = "A11L283243", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100201", WaterMeasurer = "A11L339990", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100202", WaterMeasurer = "A11L282668", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100203", WaterMeasurer = "A11L282669", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100204", WaterMeasurer = "A11L283246", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "33", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100205", WaterMeasurer = "A11L282672", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100206", WaterMeasurer = "A11L282661", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100207", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100208", WaterMeasurer = "A11L282657", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "37", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100209", WaterMeasurer = "A11L282660", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "38", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100210", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "39", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100211", WaterMeasurer = "A11L339995", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "40", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100212", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100213", WaterMeasurer = "A11L340947", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "41", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100214", WaterMeasurer = "A11L340948", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "42", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100215", WaterMeasurer = "A11L340944", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "43", SquareId = "B7", Enable = true } }, Enable = true, HasAWaterMeasurer = true });

            //manzano B-8
            context.Kardex.Add(new Kardex() { ClientId = "100216", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100217", WaterMeasurer = "A11L281458", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100218", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100219", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100220", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100221", WaterMeasurer = "A11L282240", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100222", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100223", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100224", WaterMeasurer = "A11L341843", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100225", WaterMeasurer = "A11L342426", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100226", WaterMeasurer = "A11L282523", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100227", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100228", WaterMeasurer = "A11L281462", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100229", WaterMeasurer = "A11L340949", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100230", WaterMeasurer = "A11L340943", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100231", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100233", WaterMeasurer = "A11L282519", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100236", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100237", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100238", WaterMeasurer = "A11L341448", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100239", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100240", WaterMeasurer = "A11L281573", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100241", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100242", WaterMeasurer = "A11L281772", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100243", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100244", WaterMeasurer = "A11L281672", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "33", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100245", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100246", WaterMeasurer = "A11L341751", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100247", WaterMeasurer = "A11L339999", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "37", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100248", WaterMeasurer = "A11L341368", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "41", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100249", WaterMeasurer = "A11L283238", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "42", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100250", WaterMeasurer = "A11L342654", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "43", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100251", WaterMeasurer = "A11L283245", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "45", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100252", WaterMeasurer = "A11L283237", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "46", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100253", WaterMeasurer = "A11L341948", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "47", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100254", WaterMeasurer = "A11L282756", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "48", SquareId = "B8", Enable = true } }, Enable = true, HasAWaterMeasurer = true });

            //manzano B-9
            context.Kardex.Add(new Kardex() { ClientId = "100255", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100257", WaterMeasurer = "A11L282019", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100258", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100259", WaterMeasurer = "A11L283740", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100260", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100261", WaterMeasurer = "A11L281465", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100262", WaterMeasurer = "A11L282023", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100263", WaterMeasurer = "A11L340792", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100264", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100265", WaterMeasurer = "A11L283535", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100266", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100267", WaterMeasurer = "A11L339620", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100269", WaterMeasurer = "A11L282389", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100270", WaterMeasurer = "A11L282524", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100271", WaterMeasurer = "A11L341063", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100272", WaterMeasurer = "A11L341067", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100273", WaterMeasurer = "A11L342423", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100274", WaterMeasurer = "A11L341541", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100275", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100276", WaterMeasurer = "A11L341542", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100277", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100278", WaterMeasurer = "A11L341443", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100279", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "100280", WaterMeasurer = "A11L341064", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "100281", WaterMeasurer = "A11L341948", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B9", Enable = true } }, Enable = true, HasAWaterMeasurer = true });

            //Manzano B-10
            context.Kardex.Add(new Kardex() { ClientId = "301", WaterMeasurer = "A11L341841", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "302", WaterMeasurer = "A11L281459", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "303", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "304", WaterMeasurer = "A11L341042", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "305", WaterMeasurer = "A11L282248", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "306", WaterMeasurer = "A11L283743", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "307", WaterMeasurer = "A11L341942", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "308", WaterMeasurer = "A11L281457", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "309", WaterMeasurer = "A11283742", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "310", WaterMeasurer = "A11L342420", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "311", WaterMeasurer = "A11L283745", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "312", WaterMeasurer = "A11L342425", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "313", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "314", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "315", WaterMeasurer = "A11L340942", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "316", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "318", WaterMeasurer = "A11L342657", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "320", WaterMeasurer = "A11L341725", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "321", WaterMeasurer = "A11L341725", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "322", WaterMeasurer = "A11L283527", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "323", WaterMeasurer = "A11L342659", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "324", WaterMeasurer = "A11L281460", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "325", WaterMeasurer = "A11L283533", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "326", WaterMeasurer = "A11L282246", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "327", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "33", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "328", WaterMeasurer = "A11L281464", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "329", WaterMeasurer = "A11L282244", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "330", WaterMeasurer = "A11L281466", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "36", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "331", WaterMeasurer = "A11L341756", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "37", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "332", WaterMeasurer = "A11L282391", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "38", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "333", WaterMeasurer = "A11L341441", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "39", SquareId = "B10", Enable = true } }, Enable = true, HasAWaterMeasurer = true });


            //Manzano B-11
            context.Kardex.Add(new Kardex() { ClientId = "334", WaterMeasurer = "A11L281769", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "335", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "336", WaterMeasurer = "A11L281532", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "337", WaterMeasurer = "A11L281770", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "338", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "339", WaterMeasurer = "A11L341061", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "340", WaterMeasurer = "A11L281533", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "341", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "342", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "343", WaterMeasurer = "A11L341060", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "344", WaterMeasurer = "A11L34147", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "345", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "346", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "347", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "348", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "349", WaterMeasurer = "A11L282390", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "350", WaterMeasurer = "A11L341946", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "351", WaterMeasurer = "A11L282243", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "352", WaterMeasurer = "A11L282237", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "353", WaterMeasurer = "A11L281954", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "354", WaterMeasurer = "A11L281470", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "355", WaterMeasurer = "A11L282670", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "357", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "359", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "35", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "360", WaterMeasurer = "A11L341442", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "37", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "361", WaterMeasurer = "A11L283738", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "38", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "362", WaterMeasurer = "A11L341047", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "39", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "364", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "41", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "366", WaterMeasurer = "AL11341827", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "43", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "367", WaterMeasurer = "A11L281463", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "44", SquareId = "B11", Enable = true } }, Enable = true, HasAWaterMeasurer = true });


            //Manzano B-12
            context.Kardex.Add(new Kardex() { ClientId = "368", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "369", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "370", WaterMeasurer = "A11L341444", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "371", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "372", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "373", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "8", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "374", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "375", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "376", WaterMeasurer = "A11L342417", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "377", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "378", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "379", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "380", WaterMeasurer = "A11L283534", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "18", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "381", WaterMeasurer = "A11L341440", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "382", WaterMeasurer = "A11L341048", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "21", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "383", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "23", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "384", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "24", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "385", WaterMeasurer = "A11L341754", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "25", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "386", WaterMeasurer = "A11L281472", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "387", WaterMeasurer = "A11L341446", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B12", Enable = true } }, Enable = true, HasAWaterMeasurer = true });


            //Manzano B-13
            context.Kardex.Add(new Kardex() { ClientId = "388", WaterMeasurer = "A11L341945", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "1", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "389", WaterMeasurer = "A11L282387", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "2", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "390", WaterMeasurer = "A11L282020", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "3", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "391", WaterMeasurer = "A11L283529", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "4", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "392", WaterMeasurer = "A11L283531", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "5", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "393", WaterMeasurer = "A11L282025", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "6", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "394", WaterMeasurer = "A11L283528", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "7", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "395", WaterMeasurer = "A11L281531", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "9", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "396", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "10", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "397", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "11", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "398", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "12", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "399", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "13", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "400", WaterMeasurer = "A11L282393", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "14", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "401", WaterMeasurer = "A11L339628", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "15", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "402", WaterMeasurer = "A11L281950", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "16", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "403", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "17", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "404", WaterMeasurer = "A11L282395", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "19", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "405", WaterMeasurer = "A11L282786", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "20", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "406", WaterMeasurer = "A11L282024", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "22", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "407", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "26", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "408", WaterMeasurer = "A11L341046", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "27", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "409", WaterMeasurer = "A11L342650", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "28", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "410", WaterMeasurer = "A11L282750", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "29", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "411", WaterMeasurer = "A11L340798", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "30", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "412", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "31", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "413", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "32", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "414", WaterMeasurer = "A11L342651", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "33", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "415", WaterMeasurer = "A11L3409401", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "34", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "417", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "38", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "419", WaterMeasurer = "", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "41", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = false });
            context.Kardex.Add(new Kardex() { ClientId = "420", WaterMeasurer = "A11L341449", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "42", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "421", WaterMeasurer = "A11L341940", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "43", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });
            context.Kardex.Add(new Kardex() { ClientId = "422", WaterMeasurer = "A11L341947", Allotment = new Collection<Allotment>() { new Allotment() { AllotmentName = "44", SquareId = "B13", Enable = true } }, Enable = true, HasAWaterMeasurer = true });

            context.SaveChanges();
            #endregion



        }
    }
}
